package com.yuntian.mapper;


import com.yuntian.entity.CustomerMaster;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 顧客マスタM001 顾客映射器
 * @author yuntian
 */
@Mapper
public interface CustomerMapper {

    /**
     * 获取所有顾客
     * @return 顾客列表
     */
    @Select("select * from M001")
    public List<CustomerMaster> getCustomerList();


     /**
     * 根据顾客代码查询顾客信息
     * @param kokyakuCode 顾客代码
     * @return 顾客信息DTO
     */
    @Select("select * from M001 where M00101 = #{kokyakuCode} ")
    CustomerMaster seleybycode(String kokyakuCode);
}
